# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月21日
"""
import openpyxl

myBook = openpyxl.load_workbook('员工表.xlsx', data_only=True)
mySheet = myBook.active

myNames=['Mark','Daniel','Jack','Cindy','King','Ken','Noran','Ben']
myRow=2
for myName in myNames:
	myComment=openpyxl.comments.Comment(f'英文名:{myName}','')
	mySheet['C'+str(myRow)].comment=myComment
	myRow+=1

myBook.save('结果表-员工表.xlsx')
